create procedure [dbo].[BAEImisSystemParamsWebSalesCityAndState] as
Declare @city AS varchar(128);
    Declare @state AS varchar(128);
    Declare @defaultTax AS varchar(128);
    Declare @cityTaxCode AS varchar(128);
    Declare @stateTaxCode AS varchar(128);
        
    SELECT @city = ShortValue FROM System_Params
    WHERE ParameterName = 'Order_Control.TaxAuthorityCity';

    SELECT @state = ShortValue FROM System_Params
    WHERE ParameterName = 'Order_Control.TaxAuthorityStateProvince';

    SELECT @defaultTax = ShortValue FROM System_Params
    WHERE ParameterName = 'Order_Control.UseCustomerDefaultTaxAuthority';

    SELECT @cityTaxCode = ShortValue FROM System_Params
    WHERE ParameterName = 'Order_Control.TaxAuthorityCityCode';

    SELECT @stateTaxCode = ShortValue FROM System_Params
    WHERE ParameterName = 'Order_Control.TaxAuthorityStateProvinceCode';

    SELECT @city AS City, @state AS State, @defaultTax AS DefaultTaxAuth, @cityTaxCode AS CityTaxCode, @stateTaxCode AS StateTaxCode;

GO